begin tran
declare @i int 
select @i = convert(int, var_data) 
from igs_parm with(updlock) where var_name = 'gv_upd_id'

update pos_sales_hdr set vip_no = '18627130811'
where pos_sales_hdr.vip_no = '15102763620'

update pos_vip_tran set vip_no = '18627130811'
where pos_vip_tran.vip_no = '15102763620'

exec sp_pos_recal_vip_pts '15102763620', @i
exec sp_pos_recal_vip_pts '18627130811', @i

select * from pos_vip_info where vip_no ='15102763620'
select * from pos_vip_info where vip_no ='18627130811'

commit tran